//package com.zjzywl.iotSendthings.util;
//
//
//import java.sql.*;
//import java.text.SimpleDateFormat;
//import java.util.Date;
//import java.io.*;
//
//public class SaveImageToDatabase {
//	public static void main(String[] args) throws SQLException {
//		// declare a connection by using Connection interface
//		Connection connection = null;
//		/*
//		 * Create string of connection url within specified format with machine
//		 * name, port number and database name. Here machine name id localhost
//		 * and database name is mahendra.
//		 */
//		//String connectionURL = "jdbc:mysql://localhost/sendthings";
//		String connectionURL = "jdbc:oracle:thin:@192.168.0.85:1521:orcl";
//		/*
//		 * declare a resultSet that works as a table resulted by execute a
//		 * specified sql query.
//		 */
//		ResultSet rs = null;
//		// Declare prepare statement.
//		PreparedStatement psmnt = null;
//		// declare FileInputStream object to store binary stream of given image.
//		FileInputStream fis;
//		try {
//			// Load JDBC driver "com.mysql.jdbc.Driver"
//			Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
//			//Class.forName("com.mysql.jdbc.Driver").newInstance();
//
//			/*
//			 * Create a connection by using getConnection() method that takes
//			 * parameters of string type connection url, user name and password
//			 * to connect to database.
//			 */
//			connection = DriverManager.getConnection(connectionURL, "system",
//					"zjzywl");
///*			connection = DriverManager.getConnection(connectionURL, "root",
//					"12345");
//*/			// create a file object for image by specifying full path of image
//			// as parameter.
//			File image = new File("D:/qqq.jpg");
//			/*
//			 * prepareStatement() is used for create statement object that is
//			 * used for sending sql statements to the specified database.
//			 */
//			Date Time = new Date();
//			SimpleDateFormat format1 = new SimpleDateFormat("yyyyMMddHHmmss");
//			String sjc = format1.format(Time);
//			psmnt = connection
//					.prepareStatement("insert into KSSZPB(zybh,rybh,zp,zpxh) "
//							+ "values(?,?,?)");
//			psmnt.setString(1, "330400111201510150011");
//			psmnt.setString(2, "330400111201607160007");
//			psmnt.setString(4, "0");
//			fis = new FileInputStream(image);
//			psmnt.setBinaryStream(3, (InputStream) fis, (int) (image.length()));
//			/*
//			 * executeUpdate() method execute specified sql query. Here this
//			 * query insert data and image from specified address.
//			 */
//			int s = psmnt.executeUpdate();
//			if (s > 0) {
//				System.out.println("Uploaded successfully !");
//			} else {
//				System.out.println("unsucessfull to upload image.");
//			}
//		}
//
//		// catch if found any exception during rum time.
//		catch (Exception ex) {
//			System.out.println("Found some error : " + ex);
//		} finally {
//			// close all the connections.
//			connection.close();
//			psmnt.close();
//		}
//	}
//}